DataSource JDBC
JDBC, short for Java Database Connectivity, is an API that empowers users to execute operations on a data source using the Java programming language. This versatile API facilitates connections to a wide array of Data Source systems, ranging from relational databases to spreadsheets and flat files. With the appropriate SQL syntax, you can conduct queries, updates, deletions, and even execute stored procedures.
Engaging in Practical Implementation
Open new Project in QuickIntegration Platform, and then follow these steps to get your flow working
- Click On the Connection Properties
- Select the DataSource Type from drop down
- Provide the Credentials
- Click on Submit to save the Credentials
- On the left side of the palette, you'll find the Configured Properties ready to be utilized within your API.
| Fields | Description | Example |
|---|---|---|
| DataSource Name | Datasource Name which is configured in connections properties | classicnew |
| DataSource Type | JDBC | JDBC |
| Driver ClassName | A string that identifies the primary class for a JDBC driver | com.mysql.cj.jdbc.Driver |
| URL | A URL (Uniform Resource Locator) is a unique identifier used to locate a resource on the Internet | jdbc:mysql://<server-host>:3306/<database-name> |
| Connection Timeout | The maximum amount of time the driver will wait while attempting to establish a connection to the database. | 60000 (ms) |
| User Name | A name that uses for identification purposes when logging | <server-username> |
| Password | A password is a string of characters used to verify the identity of a user during the authentication process | <server-password> |
| Environment | Provides a production environment where you can deploy applications and APIs publicly | dev |
| DataBase | Database driver | SQL |
| DDL schema (optional) | SQL file that contains table creation statements. Please refer the link for instructions on uploading DDL schema | classicmodels |